UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8swRiKRpzsY3Kyj5Hulr7DCQi00zFE88JM/xjcDPi6k='
WHERE
key_id = '17347ac255181decc218c20f2b62b3ae627570c566e7123a78b157cc025373d5'
AND (
token = '8swRiKRpzsY3Kyj5Hulr7DCQi00zFE88JM/xjcDPi6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)