UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLyxJuDn6mPoynZ0HrHSmtU03YTwmjnUW/bCNi17P68='
WHERE
key_id = 'd4c9b613d0c78372c75e44627df6e890dc8ee87cf414cbe78729e9130bb32782'
AND (
token = 'pLyxJuDn6mPoynZ0HrHSmtU03YTwmjnUW/bCNi17P68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)