UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sAeUkTId9mHsKhJZZu97k93IU4809KEbB4nK7bxn1i4='
WHERE
key_id = '055fc9b12161e52a81d6570385c0cb339d48c9b4299eb9c688949c636f918ef6'
AND (
token = 'sAeUkTId9mHsKhJZZu97k93IU4809KEbB4nK7bxn1i4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)