UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ntZjwDto2K1E1wFYeqQtCmAdI74so0lf+dmSlQSgBD8='
WHERE
key_id = 'dcfea98329538b71c18737fcb8034dc211b246c9d3fc6ab3552a64a05603087c'
AND (
token = 'ntZjwDto2K1E1wFYeqQtCmAdI74so0lf+dmSlQSgBD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)