UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '10eCcs0rEwsKhkcyaWhcdQF8WUy/CbIQbB+rsO09mRI='
WHERE
key_id = '7c8ae9461ed9ecefdc2159ad482d8fdca8a21c3eaa8df42f6c75edfbe9716506'
AND (
token = '10eCcs0rEwsKhkcyaWhcdQF8WUy/CbIQbB+rsO09mRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)