UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KY+hPozGxwB6eKXsSHUyW+8a3WY5hPJGyM5y2449qlI='
WHERE
key_id = 'c476dcea2b831f3e4919adaab06d2c2f6ed866009959b0174b3eb7a6071aa75a'
AND (
token = 'KY+hPozGxwB6eKXsSHUyW+8a3WY5hPJGyM5y2449qlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)