UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S6pG8YX2X7RFl4EeZzt/dZxgRJ2akUznHUUs5gSmm8k='
WHERE
key_id = 'fe64a3bd65ad322dc3738c3196999f720e2b53e4b9f85d292cc1c1c2f6365926'
AND (
token = 'S6pG8YX2X7RFl4EeZzt/dZxgRJ2akUznHUUs5gSmm8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)