UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHgu4MyiA589XeN8eiwZ4hMM5Lyh4rSvEnfOnrY8QDQ='
WHERE
key_id = '1ecddfa70b0d0a0ebdd7d326326cadbe6c89d6064778ad2a8c867227311a42ad'
AND (
token = 'pHgu4MyiA589XeN8eiwZ4hMM5Lyh4rSvEnfOnrY8QDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)