UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0hNaoDR3TmZ41NdZU8U69IwrFHXQkllR1lSKfggU+J0='
WHERE
key_id = '31518161e0bcd298e291ce21090ed2ef755515c87628854dad24d651a72adf68'
AND (
token = '0hNaoDR3TmZ41NdZU8U69IwrFHXQkllR1lSKfggU+J0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)