UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HHxNiYjHG8YILTyEknphc3u6VKn8HZt0QZ3YTBYe+m4='
WHERE
key_id = 'dbf87dc8193301bab79892c534db38ea20df756798700961b34509e365aae067'
AND (
token = 'HHxNiYjHG8YILTyEknphc3u6VKn8HZt0QZ3YTBYe+m4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)