UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E2kZ6Mp47RYHze90s4jdgRZ8EmXeZnSrLchOYYuKuQ4='
WHERE
key_id = 'f1a280c60531376a22b66f642129d2dc418e2824b5be9692f3e07becec54bb65'
AND (
token = 'E2kZ6Mp47RYHze90s4jdgRZ8EmXeZnSrLchOYYuKuQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)