UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ovxvsTnNBd8uPThCMr7ZpHQYl2aUN1JroBIqWpNC+JI='
WHERE
key_id = 'de871ddfbce1bf676e32f063ccece20dfa984cd45b1b96704ffc10de98ac5ce9'
AND (
token = 'ovxvsTnNBd8uPThCMr7ZpHQYl2aUN1JroBIqWpNC+JI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)