UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0tYixZS5I0HTie2rAXri9gRTTxTeBp/rRwz51AdgYes='
WHERE
key_id = 'a7be9946a391e7ccc513b150c0264ab563e55458ac0e0c0892f1eb6069404763'
AND (
token = '0tYixZS5I0HTie2rAXri9gRTTxTeBp/rRwz51AdgYes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)