UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'esUfru045ZlSiHMt+MsxS5MsNYOXzznHVcnPEifsoeI='
WHERE
key_id = '097bdffa8cc5cd20c43d28ed9d4daf374aba15d59fe5cff00e6629cb50de3301'
AND (
token = 'esUfru045ZlSiHMt+MsxS5MsNYOXzznHVcnPEifsoeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)