UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4kdA2g2F4tyeF1s9B5S9KoDXsoxG6B7/xyR9wZiWWHk='
WHERE
key_id = '31d2e2dcfda0eb40213db5d7630343c6c4cb11d183f76de1f3ac119aa8e6ef1a'
AND (
token = '4kdA2g2F4tyeF1s9B5S9KoDXsoxG6B7/xyR9wZiWWHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)