UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vNYPtk96F4Kg+sSo7X1kZK7Ydh/42+GvvSkFeHW5nmU='
WHERE
key_id = 'd8789d00c7a382cade82bd59070590c86ff6d39187db7ce1523ac61d4538b762'
AND (
token = 'vNYPtk96F4Kg+sSo7X1kZK7Ydh/42+GvvSkFeHW5nmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)