UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b8vekXn/5aAmx+7U0bimTDv0x+6Y1j0odtHa9LH+rgU='
WHERE
key_id = 'c478a2802db12a1a4e0eb039e4b4af492eb48fcde10ed3e9d746cee6d129fd08'
AND (
token = 'b8vekXn/5aAmx+7U0bimTDv0x+6Y1j0odtHa9LH+rgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)