UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NF9Klx++UeAPhOat+PS9Fnz0zbxjNaduwp41EZf+c+w='
WHERE
key_id = '784fe49d72788e078f4a31b2f23bfbc549613799e0d4623a748521233fbb2d60'
AND (
token = 'NF9Klx++UeAPhOat+PS9Fnz0zbxjNaduwp41EZf+c+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)