UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p+HH14loUaOSYKuOc6IFwG5Yugk/9JaunZqgE66P15E='
WHERE
key_id = 'e262bafd2c9f5b42914a334976bd7105c12ea1de6f2299acbd30790b10e526ef'
AND (
token = 'p+HH14loUaOSYKuOc6IFwG5Yugk/9JaunZqgE66P15E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)