UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's5ozBpXqduGL76QNDejnYgGedSIkyfqP3IhdozaWvwk='
WHERE
key_id = 'bbfc0aa97bcf62f01f484f0eb9ff843ffdda7090896e7eefae08de6e1fa98b2a'
AND (
token = 's5ozBpXqduGL76QNDejnYgGedSIkyfqP3IhdozaWvwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)