UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjI4Gn21z583r38WmFW9jcXxOSqeVu9hs4OUCBo8P28='
WHERE
key_id = '831402ca50818f9c90224c2aa53543ae71e39a79bb7a5d9e22555e53b184333a'
AND (
token = 'mjI4Gn21z583r38WmFW9jcXxOSqeVu9hs4OUCBo8P28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)