UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2R1i9QHQRpncGM3JmFHUicO0dXKkXRrwwJP6LCcWUX8='
WHERE
key_id = 'd0d626ce96c861085cb8fd4491275ed714f26ea6079c0495a91f02ebd6ad181a'
AND (
token = '2R1i9QHQRpncGM3JmFHUicO0dXKkXRrwwJP6LCcWUX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)