UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pDn66eJCt7u5xkHCEWWHGkSPB6++1Fua6ytEke70D3M='
WHERE
key_id = 'eed886ae25f8fc7136de0e86415b4b8b405835064548c21cb460edc639e3d8a9'
AND (
token = 'pDn66eJCt7u5xkHCEWWHGkSPB6++1Fua6ytEke70D3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)