UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9fjl0tE8cak/6dPkv034gVGX3AXt3FVEwkEBku89wk='
WHERE
key_id = 'ebf8ff51229322c45b6503019e3fe5bcb86a53621109da76d480427191c89174'
AND (
token = 'R9fjl0tE8cak/6dPkv034gVGX3AXt3FVEwkEBku89wk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)