UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aHZcyI/8B2tmTXZ7QtNzz6w5u7J02KdnpibHWD2xV80='
WHERE
key_id = '13593f6ee0d5ba54ddff9fd81121ee0628a5ecc3cff926a4cf54ab815684fa96'
AND (
token = 'aHZcyI/8B2tmTXZ7QtNzz6w5u7J02KdnpibHWD2xV80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)