UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGLvM5ausOa+6L+dGiT4cS8Az/Kt5cLstj17qvHHl/I='
WHERE
key_id = 'f3206d680ffee1c9e7e8c7596f100a2df18e4b78c7e8819ea54be027b8b9a8e7'
AND (
token = 'VGLvM5ausOa+6L+dGiT4cS8Az/Kt5cLstj17qvHHl/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)