UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oiaB5mIdSAjviloywt0X2zUEUW4b/AaVWaTkPFB7z2U='
WHERE
key_id = 'df111ccb44778fa4c1d20513cfce90a8c76e8f14ea2c27143f2ac2efb1655f5e'
AND (
token = 'oiaB5mIdSAjviloywt0X2zUEUW4b/AaVWaTkPFB7z2U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)