UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UoSs09BOhgZjW6AjmEKsOI0E0Kq0mvvgr4LMzJIQdl0='
WHERE
key_id = '1e49b11deccb403a8e1501d2c67ca3713b5d6573aa09e0d415e2d632428a7643'
AND (
token = 'UoSs09BOhgZjW6AjmEKsOI0E0Kq0mvvgr4LMzJIQdl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)