UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3W9BJq5d1T+pSAQJpeSw8zE/BCcIBGUoj3YAF1PMHjw='
WHERE
key_id = 'b6f10743b8e3fbd6fdcab698c6d6f002d1bc07a743b191f1808f93865812ec6a'
AND (
token = '3W9BJq5d1T+pSAQJpeSw8zE/BCcIBGUoj3YAF1PMHjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)