UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1L0BeGPCuoPw7oromnILI2I+8ylcmxFEVhTB5+u5KyA='
WHERE
key_id = 'ceec7ce115784ebaeb8c4ade877aaa330341cd23536e8d0f60055bd0537d83fd'
AND (
token = '1L0BeGPCuoPw7oromnILI2I+8ylcmxFEVhTB5+u5KyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)