UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Ao+Hlw1UeQ30sbLArIuIgghiMFnPwNIqi8yny8OSoI='
WHERE
key_id = 'af5b7a4be76cc3188985ba59239fe87f0917324db30012506e01765efbe68566'
AND (
token = '6Ao+Hlw1UeQ30sbLArIuIgghiMFnPwNIqi8yny8OSoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)