UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNe/aemoC54RZeySCWmtM2CCa15krUvXp/3Ks/JFyVg='
WHERE
key_id = '6b7a234aaf4e8f35b45134cf8f4aa1ede57a965cd85fb97f2da39c2da72da59c'
AND (
token = 'cNe/aemoC54RZeySCWmtM2CCa15krUvXp/3Ks/JFyVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)