UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkDl0CCZ0JYiqCc0JLgI7kvmIXocuaijOBNZnSCK/r8='
WHERE
key_id = '62be7d3e3616f0fa0a002e508fee9e767baa7a60036bb576719cb9e41dc89046'
AND (
token = 'zkDl0CCZ0JYiqCc0JLgI7kvmIXocuaijOBNZnSCK/r8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)